﻿	CREATE SET TABLE SUNRISE_TEST.ACC_BASE_DATA ,NO FALLBACK ,
	     NO BEFORE JOURNAL,
	     NO AFTER JOURNAL,
	     CHECKSUM = DEFAULT
	     (
	      ASOF_DATE DATE FORMAT 'YYYY-MM-DD',
	      REGION CHAR(12) CHARACTER SET LATIN NOT CASESPECIFIC COMPRESS 'SOUTHEAST   ',
	      MARKET CHAR(4) CHARACTER SET LATIN NOT CASESPECIFIC COMPRESS ('ALM ','FL  ','GA  ','KTNS'),
	      TRAC_ID CHAR(10) CHARACTER SET LATIN NOT CASESPECIFIC,
	      PROGRAM CHAR(5) CHARACTER SET LATIN NOT CASESPECIFIC COMPRESS ('APT  ','CONDO','SFU  '),
	      NATIONAL_IND CHAR(1) CHARACTER SET LATIN NOT CASESPECIFIC COMPRESS ('N','Y'),
	      PORTFOLIO VARCHAR(100) CHARACTER SET LATIN NOT CASESPECIFIC,
	      PROPERTY_NM VARCHAR(100) CHARACTER SET LATIN NOT CASESPECIFIC,
	      AREA_MGR VARCHAR(50) CHARACTER SET LATIN NOT CASESPECIFIC,
	      SALES_ENG VARCHAR(50) CHARACTER SET LATIN NOT CASESPECIFIC,
	      ACCT_MGR VARCHAR(50) CHARACTER SET LATIN NOT CASESPECIFIC,
	      STRATEGY_IND CHAR(1) CHARACTER SET LATIN NOT CASESPECIFIC COMPRESS ('S','V'),
	      HAS_ADDRS CHAR(1) CHARACTER SET LATIN NOT CASESPECIFIC DEFAULT 'N' COMPRESS ('N','Y'))
	UNIQUE PRIMARY INDEX ( TRAC_ID );


	CREATE SET TABLE SUNRISE_TEST.ACC_TRAC_ID_SUMMARY ,NO FALLBACK ,
	     NO BEFORE JOURNAL,
	     NO AFTER JOURNAL,
	     CHECKSUM = DEFAULT
	     (
	      STATE_CD CHAR(2) CHARACTER SET LATIN NOT CASESPECIFIC COMPRESS ('AL','FL','GA','KY','LA','MS','NC','SC','TN'),
	      TRAC_ID CHAR(10) CHARACTER SET LATIN NOT CASESPECIFIC,
	      TRAC_NUM INTEGER,
	      ACCT_MGR CHAR(25) CHARACTER SET LATIN NOT CASESPECIFIC COMPRESS ('ADAMS, JOYA              ','AM AL VACANT             ','AM FL VACANT             ','AM GA VACANT             ','AM KY VACANT             ','AM LA VACANT             ','AM MS VACANT             ','AM SC VACANT             ','ASHLEY, DONNA            ','BARNES, JENNY            ','COLLINS, SHERRI          ','CROZIER, GREG            ','DUKES, SHARON            ','GOENS, AL                ','HAWKS, SCOTT             ','HOPPER, TIFFANY          ','JACKSON, TERESA          ','KATZ, STEVE              ','KEE, LEANDER             ','LESLEY, SHERRY           ','LIDY, TRACY              ','MARALDO, ED              ','MARTINEZ, LEONTE         ','MORRIS, BARRY            ','MORRIS, LENNY            ','NAMIE, LESLEY            ','ROGERS, PAIGE            ','SIPLIN, DANNY            ','SPICER, CARRIE           ','STALNAKER, DEBORAH       ','STEED, DAWN              ','THOMAS, GLENN            '),
	      AREA_MGR CHAR(25) CHARACTER SET LATIN NOT CASESPECIFIC COMPRESS ('AMY MARTIN               ','CATHY MARINO             ','INTERNAL AREA MGR        ','MICHAEL BOBKO            ','ROGER THARRINGTON        '),
	      PORTFOLIO_NM VARCHAR(100) CHARACTER SET LATIN NOT CASESPECIFIC,
	      PROPERTY_NM VARCHAR(100) CHARACTER SET LATIN NOT CASESPECIFIC,
	      ADDRESSES INTEGER COMPRESS (100 ,120 ),
	      GREENS INTEGER COMPRESS 0 ,
	      SUBSCRIBERS INTEGER COMPRESS (0 ,1 ,2 ),
	      HSIA INTEGER COMPRESS (0 ,1 ,2 ),
	      IPTV INTEGER COMPRESS (0 ,1 ,2 ),
	      VOIP INTEGER COMPRESS 0 ,
	      HSIA_REVENUE DECIMAL(7,2) COMPRESS 0.00 ,
	      IPTV_REVENUE DECIMAL(7,2) COMPRESS 0.00 ,
	      VOIP_REVENUE DECIMAL(7,2) COMPRESS 0.00 ,
	      OTHER_UVERSE_REVENUE DECIMAL(7,2) COMPRESS 0.00 ,
	      TOTAL_REVENUE DECIMAL(7,2) COMPRESS 0.00 )
	UNIQUE PRIMARY INDEX ( TRAC_ID );

